<html>
<head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
    <title>主要内容区main</title>
    <link href="css/css.css" type="text/css" rel="stylesheet" />
    <link href="css/main.css" type="text/css" rel="stylesheet" />
    <link rel="shortcut icon" href="images/main/favicon.ico" />
    <style>
        body{overflow-x:hidden; background:#f2f0f5; padding:15px 0px 10px 5px;}
        #searchmain{ font-size:12px;}
        #search{ font-size:12px; background:#548fc9; margin:10px 10px 0 0; display:inline; width:100%; color:#FFF; float:left}
        #search form span{height:40px; line-height:40px; padding:0 0px 0 10px; float:left;}
        #search form input.text-word{height:24px; line-height:24px; width:180px; margin:8px 0 6px 0; padding:0 0px 0 10px; float:left; border:1px solid #FFF;}
        #search form input.text-but{height:24px; line-height:24px; width:55px; background:url(images/main/list_input.jpg) no-repeat left top; border:none; cursor:pointer; font-family:"Microsoft YaHei","Tahoma","Arial",'宋体'; color:#666; float:left; margin:8px 0 0 6px; display:inline;}
        #search a.add{ background:url(images/main/add.jpg) no-repeat -3px 7px #548fc9; padding:0 10px 0 26px; height:40px; line-height:40px; font-size:14px; font-weight:bold; color:#FFF; float:right}
        #search a:hover.add{ text-decoration:underline; color:#d2e9ff;}
        #main-tab{ border:1px solid #eaeaea; background:#FFF; font-size:12px;}
        #main-tab th{ font-size:12px; background:url(images/main/list_bg.jpg) repeat-x; height:32px; line-height:32px;}
        #main-tab td{ font-size:12px; line-height:40px;}
        #main-tab td a{ font-size:12px; color:#548fc9;}
        #main-tab td a:hover{color:#565656; text-decoration:underline;}
        .bordertop{ border-top:1px solid #ebebeb}
        .borderright{ border-right:1px solid #ebebeb}
        .borderbottom{ border-bottom:1px solid #ebebeb}
        .borderleft{ border-left:1px solid #ebebeb}
        .gray{ color:#dbdbdb;}
        td.fenye{ padding:10px 0 0 0; text-align:right;}
        .bggray{ background:#f9f9f9}
    </style>
</head>
<body>
<!--main_top-->
<table width="99%" border="0" cellspacing="0" cellpadding="0" id="searchmain">
    <tr>
        <td width="99%" align="left" valign="top">您的位置：文章列表</td>
    </tr>
    <tr>
        <td align="left" valign="top">
            <table width="100%" border="0" cellspacing="0" cellpadding="0" id="search">
                <tr>
                    <td width="90%" align="left" valign="middle">
                        <form method="post" action="">
                            <span>管理员：</span>
                            <input type="text" name="" value="" class="text-word">
                            <input name="" type="button" value="查询" class="text-but">
                        </form>
                    </td>

                </tr>
            </table>
        </td>
    </tr>
    <tr>
        <td align="left" valign="top">

            <table width="100%" border="0" cellspacing="0" cellpadding="0" id="main-tab">
                <tr>
                    <th align="center" valign="middle" class="borderright">编号</th>
                    <th align="center" valign="middle" class="borderright">文章标题</th>
                    <th align="center" valign="middle" class="borderright">内容</th>
                    <th align="center" valign="middle" class="borderright">是否显示</th>
                    <th align="center" valign="middle" class="borderright">文章类型</th>

                    <th align="center" valign="middle" class="borderright">发表时间</th>
                    <th align="center" valign="middle">操作</th>
                </tr>

                <?php
                require_once "config.php";
                $allsql="select * from article";
                $count=mysqli_num_rows(mysqli_query($con,$allsql));
                $length = 15;
                $page = isset($_GET['page'])?$_GET['page']:1;
                $pagenum=ceil($count/$length);

                if($page > $pagenum){
                    $page = $pagenum;
                }
                if($page < 1 ){
                    $page = 1;
                }
                $ofset = ($page-1)*$length;
                //$pagesql = "select * from admin order by id asc limit $ofset,$length";
                //$pagerst = mysqli_query($con,$pagesql);

                $sql = "select * from liuyan order by id desc limit $ofset,$length";
                $rst = mysqli_query($con,$sql);
                $i = 1;
                while($row = mysqli_fetch_assoc($rst)){
                    $sql1 = "select * from category where id = {$row['cateid']}";
                    $rst1 = mysqli_query($con,$sql1);
                    $row1 = mysqli_fetch_assoc($rst1);
                    if($i % 2 != 0){
                        ?>
                        <tr onMouseOut="this.style.backgroundColor='#ffffff'" onMouseOver="this.style.backgroundColor='#edf5ff'">
                            <td align="center" valign="middle" class="borderright borderbottom"><?php echo $row['id']; ?></td>
                            <td align="center" valign="middle" class="borderright borderbottom"><?php echo $row['title']; ?></td>
                            <td align="center" valign="middle" class="borderright borderbottom"><?php echo $row['author']; ?></td>
                            <td align="center" valign="middle" class="borderright borderbottom"><?php if($row['flag']==1){ echo "显示";}else{echo "未显示";} ?></td>
                            <td align="center" valign="middle" class="borderright borderbottom"><?php echo $row1['cate_name']; ?></td>

                            <td align="center" valign="middle" class="borderright borderbottom"><?php echo date("Y-m-d H:i:s",$row['time']); ?></td>
                            <td align="center" valign="middle" class="borderbottom"><a href="article_look.php?id=<?php echo $row['id']; ?>" target="mainFrame" onFocus="this.blur()" class="add">查看</a><span class="gray">&nbsp;|&nbsp;</span><a href="article_edit.php?id=<?php echo $row['id']; ?>" target="mainFrame" onFocus="this.blur()" class="add">编辑</a><span class="gray">&nbsp;|&nbsp;</span><a href="article_delete.php?id=<?php echo $row['id']; ?>" target="mainFrame" onFocus="this.blur()" class="add">删除</a></td>
                        </tr>
                        <?php
                    }
                    else{
                        ?>
                        <tr class="bggray" onMouseOut="this.style.backgroundColor='#f9f9f9'" onMouseOver="this.style.backgroundColor='#edf5ff'">
                            <td align="center" valign="middle" class="borderright borderbottom"><?php echo $row['id']; ?></td>
                            <td align="center" valign="middle" class="borderright borderbottom"><?php echo $row['title']; ?></td>
                            <td align="center" valign="middle" class="borderright borderbottom"><?php echo $row['author']; ?></td>
                            <td align="center" valign="middle" class="borderright borderbottom"><?php if($row['flag']==1){ echo "显示";}else{echo "未显示";} ?></td>
                            <td align="center" valign="middle" class="borderright borderbottom"><?php echo $row1['cate_name']; ?></td>

                            <td align="center" valign="middle" class="borderright borderbottom"><?php echo date("Y-m-d H:i:s",$row['time']); ?></td>
                            <td align="center" valign="middle" class="borderbottom"><a href="article_look.php?id=<?php echo $row['id']; ?>" target="mainFrame" onFocus="this.blur()" class="add">查看</a><span class="gray">&nbsp;|&nbsp;</span><a href="article_edit.php?id=<?php echo $row['id']; ?>" target="mainFrame" onFocus="this.blur()" class="add">编辑</a><span class="gray">&nbsp;|&nbsp;</span><a href="article_delete.php?id=<?php echo $row['id']; ?>" target="mainFrame" onFocus="this.blur()" class="add">删除</a></td>
                        </tr>
                        <?php
                    }
                    $i++;
                }
                ?>
                <tr style="text-align: center;"><td colspan="4"><a href="article_list.php?page=<?php echo $page-1; ?>">上一页</a></td>
                    <td colspan="2"><a href="article_list.php?page=<?php echo $page+1; ?>" >下一页</a></td>
                </tr>
            </table></td>
    </tr>

</table>

</body>
</html>